CREATE external  TABLE jms_ods.high_risk_user (
  id bigint COMMENT 'ID',
  first_level_code string  COMMENT '一级分类code',
  first_level_name string  COMMENT '一级分类名称',
  second_level_code string  COMMENT '二级分类code',
  second_level_name string  COMMENT '二级类型名称',
  user_phone string COMMENT '用户手机号',
  label_name string COMMENT '标签名称',
  day_range int COMMENT '取值范围（天）',
  remarks string COMMENT '备注',
  create_time timestamp  COMMENT '创建时间',
  create_by_code string COMMENT '创建人code',
  create_by_name string COMMENT '创建人名称',
  update_time timestamp  COMMENT '更新时间',
  update_by_code string COMMENT '更新人code',
  update_by_name string COMMENT '更新人名称',
  label_code string COMMENT '标签编码',
  is_valid tinyint COMMENT '生效状态 1:生效 2:失效',
  sign_type tinyint COMMENT '标记类型 1:长期 2:临时',
  sign_time timestamp  COMMENT '标记时间',
  user_safety_phone string
) COMMENT  '高危用户表'
PARTITIONED BY(
dt string COMMENT'时间分区(yyyy-MM-dd)')
stored as parquet
LOCATION
'/dw/hive/jms_ods.db/external/high_risk_user'
TBLPROPERTIES(
'parquet.column.index.access'='true'
);